
-- Add Built in groups
INSERT INTO Forum_Groups (groupid, groupname, namecolor) VALUES (0, 'Anonymous', '#666666')
INSERT INTO Forum_Groups (groupid, groupname, namecolor) VALUES (1, 'Registered', '#000000')
INSERT INTO Forum_Groups (groupid, groupname, namecolor) VALUES (99999, 'Administrator', '#AA0000')


-- Add Access types
INSERT INTO Forum_AccessTypes (AccessTypeID, Description) VALUES (0, 'No access')
INSERT INTO Forum_AccessTypes (AccessTypeID, Description) VALUES (1, 'Readonly')
INSERT INTO Forum_AccessTypes (AccessTypeID, Description) VALUES (2, 'Reply only')
INSERT INTO Forum_AccessTypes (AccessTypeID, Description) VALUES (3, 'Full posting')
INSERT INTO Forum_AccessTypes (AccessTypeID, Description) VALUES (100, 'Moderation')

-- Create admin account
DECLARE @thedate datetime
SET @thedate = getdate()

EXEC Forum_InsertUser 'admin', 'f8G5lNTwJjoEaMszjEsteN0kwGMMn2gu1A==', 'admin@nowhere.com', 99999, '', @thedate, 1, '', ''

DECLARE @adminID int
SELECT @adminID = userID FROM FORUM_Users WHERE username='admin'

INSERT INTO Site_UserSettings (userid, collapsethreshold, smileysbydefault, showsignatures, returntolistafterposting) VALUES (@adminID, 0, 1, 1, 1)
